<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"
	import="java.util.*,java.io.*, java.sql.*, dbAccess.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@page import="java.text.SimpleDateFormat"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>List of Appointments</title>
<link rel="stylesheet" type="text/css" href="css_files/style.css" />
<script type="text/javascript">
function changeNumberofDays(code)
{
	var mylist;
	if (code == "1")
	{
		mylist = document.forms["frmSearchByRange"].cmbStartMonth;
	}
	else if (code == "2")
	{
		mylist = document.forms["frmSearchByRange"].cmbEndMonth;
	}
	else
	{
		mylist = document.forms["frmCreateAppt"].cmbMonth;
	}
	var month = mylist.selectedIndex;
	if ((month == 0) || (month == 2) || (month == 4) || (month == 6) || (month == 7) || (month == 9) || (month == 11))
	{
		var days;
		if (code == "1")
		{
			days = document.forms["frmSearchByRange"].cmbStartDate;
		}
		else if (code == "2")
		{
			days = document.forms["frmSearchByRange"].cmbEndDate;
		}
		else
		{
			days = document.forms["frmCreateAppt"].cmbDate;
		}
		days.options.length = 0;
		var i = 1;
		for (i = 1; i <= 31; i++)
		{
			var opt = document.createElement("option");
			days.options.add(opt);
			opt.text = i;
			opt.value = i;
		}
	}
	else if (month == 1)
	{
		var days;
		if (code == "1")
		{
			days = document.forms["frmSearchByRange"].cmbStartDate;
		}
		else if (code == "2")
		{
			days = document.forms["frmSearchByRange"].cmbEndDate;
		}
		else
		{
			days = document.forms["frmCreateAppt"].cmbDate;
		}
		days.options.length = 0;
		var i = 1;
		for (i = 1; i <= 28; i++)
		{
			var opt = document.createElement("option");
			days.options.add(opt);
			opt.text = i;
			opt.value = i;
		}
	}
	else
	{
		var days;
		if (code == "1")
		{
			days = document.forms["frmSearchByRange"].cmbStartDate;
		}
		else if (code == "2")
		{
			days = document.forms["frmSearchByRange"].cmbEndDate;
		}
		else
		{
			days = document.forms["frmSearchByRange"].cmbDate;
		}
		days.options.length = 0;
		var i = 1;
		for (i = 1; i <= 30; i++)
		{
			var opt = document.createElement("option");
			days.options.add(opt);
			opt.text = i;
			opt.value = i;
		}
	}
}

function askAgain()
{
	alert("Are you sure?");
}
	
</script>
</head>
<body>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
	<!--DWLayoutTable-->
	<tr>
		<td width="150" height="125" valign="top"><img src="images/caduceus.gif" alt=""
			name="LogoLeft" width="150" height="125" id="LogoLeft"
			style="background-color: #0033FF" /></td>
		<td width="692" align="center" valign="middle">
		<h1 align="center">CADUCEUS HOSPITAL</h1>
		</td>
		<td width="157" valign="top"><img src="images/hospital.jpg" alt="" name="LogoRight"
			width="150" height="125" id="LogoRight"
			style="background-color: #0033FF" /></td>
	</tr>
	<tr>
		<td height="19" colspan="2" valign="top">Welcome <%=session.getAttribute("Name")%>&nbsp;<%=new java.util.Date()%></td>
		<td><a href="home.jsp" title="Logout">Logout</a></td>
	</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
	<!--DWLayoutTable-->
	<tr>
		<td width="259" valign="top">
		<p class="style2"><strong>Appointment Search</strong></p>
		 <form name="frmSearchByRange" method="post" action="staff2appt.jsp">
    	<table>
    		<tr>
    			<td>
    				<strong>Search For Appointments:</strong>
    			</td>
    		</tr>
    		<tr>
    			<td>
    				<p align="center"><strong>Start Date Range </strong></p>
                 <p align="center"><strong>Year</strong> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                       <select name="cmbStartYear" id="cmbStartYear">
                       <option>2009</option>
                       </select>
                                </p>
                 <p align="center"><strong>Month</strong>&nbsp;&nbsp;&nbsp;
                       <select name="cmbStartMonth" id="cmbStartMonth" onchange="changeNumberofDays('1')">
                         <option>January</option>
                         <option>February</option>
                         <option>March</option>
                         <option>April</option>
                         <option>May</option>
                         <option>June</option>
                         <option>July</option>
                         <option>August</option>
                         <option>September</option>
                         <option>October</option>
                         <option>November</option>
                         <option>December</option>
                       </select>
                   </p>
                 <p align="center"><strong>Date</strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                       <select name="cmbStartDate" id="cmbStartDate">
                         <option>1</option>
                         <option>2</option>
                         <option>3</option>
                         <option>4</option>
                         <option>5</option>
                         <option>6</option>
                         <option>7</option>
                         <option>8</option>
                         <option>9</option>
                         <option>10</option>
                         <option>11</option>
                         <option>12</option>
                         <option>13</option>
                         <option>14</option>
                         <option>15</option>
                         <option>16</option>
                         <option>17</option>
                         <option>18</option>
                         <option>19</option>
                         <option>20</option>
                         <option>21</option>
                         <option>22</option>
                         <option>23</option>
                         <option>24</option>
                         <option>25</option>
                         <option>26</option>
                         <option>27</option>
                         <option>28</option>
                         <option>29</option>
                         <option>30</option>
                         <option>31</option>
                       </select>
                   </p>
                 <p align="center">&nbsp;</p>
    			</td>
    		</tr>
    		<tr>
    			<td>
    				<p align="center">End Date Range </p>
                 <p align="center">Year &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                       <select name="cmbEndYear" id="cmbEndYear">
                         <option>2009</option>
                                            </select>
                                </p>
                 <p align="center">Month &nbsp;&nbsp;&nbsp;
                   <select name="cmbEndMonth" id="select2" onChange="changeNumberofDays('2')">
                     <option>January</option>
                     <option>February</option>
                     <option>March</option>
                     <option>April</option>
                     <option>May</option>
                     <option>June</option>
                     <option>July</option>
                     <option>August</option>
                     <option>September</option>
                     <option>October</option>
                     <option>November</option>
                     <option>December</option>
                   </select>
                 </p>
                 <p align="center">Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                       <select name="cmbEndDate" id="select3">
                         <option>1</option>
                         <option>2</option>
                         <option>3</option>
                         <option>4</option>
                         <option>5</option>
                         <option>6</option>
                         <option>7</option>
                         <option>8</option>
                         <option>9</option>
                         <option>10</option>
                         <option>11</option>
                         <option>12</option>
                         <option>13</option>
                         <option>14</option>
                         <option>15</option>
                         <option>16</option>
                         <option>17</option>
                         <option>18</option>
                         <option>19</option>
                         <option>20</option>
                         <option>21</option>
                         <option>22</option>
                         <option>23</option>
                         <option>24</option>
                         <option>25</option>
                         <option>26</option>
                         <option>27</option>
                         <option>28</option>
                         <option>29</option>
                         <option>30</option>
                         <option>31</option>
                       </select>
                   </p>
               <p align="center">&nbsp;</p>
    			</td>
    		</tr>
    		<tr>
    			<td>
    				 <input name="cmdSearch" type="submit" id="cmdSearch" value="Search">
    			</td>
    		</tr>
				
					<td height="220" valign="top" class="style2"><p><strong>Quicklinks</strong></p>
				    <p><a href="createPatient.jsp">Create New Patient</a></p>
					<p><a href="createAppt.jsp">Create New Appointment</a></p>
					<p><a href="staff2appt.jsp">View Future Appointments</a></p>
				    <p><a href="patientListforStaff.jsp">View Patient List</a></p>
				    <p><a href="createStaff.jsp">Change Personal Information</a></p>
				    <p><a href="http://www.webmd.com">WebMD</a></p>
				    <p><a href="staffHome.jsp">Back to Homepage</a></p>
				    <p><a href="#"></a></p>
				    <p>&nbsp;</p></td>
    	</table>
    	</form>
		</td>
		<td width="740" rowspan="2" valign="top">
		<h3 align="left"><strong> List of Appointments </strong></h3>
		<table width="100%" border="1">
			<thead>
				<tr>
					<td><strong> Appointment ID </strong></td>
					<td><strong> Patient Name </strong></td>
					<td><strong>Date (yyyy-mm-dd)</strong></td>
					<td><strong> Start Time </strong></td>
					<td><strong> End Time </strong></td>
					<td><strong>Building</strong></td>
					<td><strong> Room Number </strong></td>
					<td><strong> Action </strong></td>
				</tr>
			</thead>
			<%
				Login lgn = new Login();
				ResultSet rs;
				int appointmentId = 0;
				String patientName = "unknown";
				java.sql.Time startTime = Time.valueOf("00:00:00");
				java.sql.Time endTime = Time.valueOf("00:00:00");
				String building = "unknown";
				String roomNum = "unknown";
				java.sql.Date apptDate;
				int visitId = 0;


				if (request.getParameter("cmbStartMonth") != null) 
				{
					String startYear = request.getParameter("cmbStartYear").toString();
					String startMonth = request.getParameter("cmbStartMonth").toString();
					String startDay = request.getParameter("cmbStartDate").toString();
					String startDate = startYear + "-" + Login.monthFormat(startMonth) + "-" + startDay;

					String endYear = request.getParameter("cmbEndYear").toString();
					String endMonth = request.getParameter("cmbEndMonth").toString();
					String endDay = request.getParameter("cmbEndDate").toString();
					String endDate = endYear + "-" + Login.monthFormat(endMonth) + "-" + endDay;

					java.sql.Date sDateSQL = java.sql.Date.valueOf(startDate);
					java.sql.Date eDateSQL = java.sql.Date.valueOf(endDate);
					rs = lgn.getAppointmentList((Integer) session.getAttribute("staffId"), "Staff", sDateSQL, eDateSQL);
				} 
				else
				{
					String todayString = new SimpleDateFormat("yyyy-MM-dd").format(new java.util.Date());
					java.sql.Date today = java.sql.Date.valueOf(todayString);
					java.sql.Date endOfTime = java.sql.Date.valueOf("2020-12-31");
					rs = lgn.getAppointmentList((Integer) session.getAttribute("staffId"), "Staff", today,endOfTime);
				}

				while (rs.next()) {
					appointmentId = rs.getInt("tbl_appointment.Appointmentid");
					patientName = rs.getString("patientFirstName") + " " + rs.getString("patientLastName");
					apptDate = rs.getDate("tbl_appointment.Date");
					startTime = rs.getTime("tbl_appointment.StartTime");
					endTime = rs.getTime("tbl_appointment.EndTime");
					building = rs.getString("tbl_appointment.Building");
					roomNum = rs.getString("tbl_appointment.Room");
					visitId = rs.getInt("tbl_visit.VisitId");
				%>

			<tbody>
				<tr>
					<td><%=appointmentId%></td>
					<td><%=patientName%></td>
					<td><%=apptDate%></td>
					<td><%=startTime%></td>
					<td><%=endTime%></td>
					<td><%=building%></td>
					<td><%=roomNum%></td>
					<%
						if (apptDate.compareTo(new java.util.Date()) > 0)
						{
					%>
						<td><a href="cancelAppt.jsp?apptId=<%=appointmentId%>" onclick="askAgain()">Cancel</a></td>
					<%
						}
						else
						{
					%>
						<td><a href="patientVisit.jsp?vId=<%=visitId%>callerId=staff2appt">View Visit Details</a></td>
					<%
						}
					%>
					
				</tr>
			</tbody>
			<%
			}
			%>
			</table>
		</td>
 <td width="251" height="153" valign="top"><p align="center"><strong> Search for a Person</strong></p>
     <form id="frmSearch" name="frmSearch" method="post" action="searchByStaff.jsp">
         <p> 
		<input name="personType" type="radio" value="Patient" checked>
        Patient&nbsp;
        <input name="personType" type="radio" value="Doctor">
        Doctor&nbsp;
        <input name="personType" type="radio" value="Staff">
        Staff </p>
        <p>
        &nbsp;&nbsp;Search for 
          <input type="text" name="TextField1" id="TextField1" />
          <br />
          &nbsp;&nbsp;in&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
          <select name="SearchField1" id="SearchField1">
            <option selected="selected">FirstName</option>
            <option>LastName</option>
            <option>HomeAddress</option>
            <option>Gender</option>
            <option>Phone</option>
            <option>EmailAddress</option>
            <option>DateOfBirth</option>
            <option>Id</option>
            </select>
      </p>
        <p class="style5">&nbsp;<em>AND</em></p>
        <p>&nbsp;&nbsp;Search for
          <input type="text" name="TextField2" id="TextField2" />
          <br />
          &nbsp;&nbsp;in&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <select name="SearchField2" id="SearchField2">
                   <option selected="selected">FirstName</option>
            <option>LastName</option>
            <option>HomeAddress</option>
            <option>Gender</option>
            <option>Phone</option>
            <option>EmailAddress</option>
            <option>DateOfBirth</option>
            <option>Id</option>
         	</select>
        </p>
        <p>&nbsp;<em>AND</em></p>
        <p>&nbsp;&nbsp;Search for
          <input type="text" name="TextField3" id="TextField3" />
            <br />
          &nbsp;&nbsp;in&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  			<select name="SearchField3" id="SearchField3">
            <option selected="selected">FirstName</option>
            <option>LastName</option>
            <option>HomeAddress</option>
            <option>Gender</option>
            <option>Phone</option>
            <option>EmailAddress</option>
            <option>DateOfBirth</option>
            <option>Id</option>
  			</select>
        </p>
        <p align="center">
          <input type="submit" name="Search1" id="Search1" value="Search" />
        </p>
      </form>    </td>
	</tr>
  
</table>
</body>
</html>

